package com.mrtan.mapper;

import com.mrtan.bean.SupplierProduct;
import com.mrtan.dto.MCDto;
import com.mrtan.vo.AddSupplierProductVO;
import com.mrtan.vo.SupplierProductVO;
import com.mrtan.vo.UpdateSupplierProduct;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author Mr.Tan
 * @description 针对表【supplier_product(供应商产品)】的数据库操作Mapper
 * @createDate 2023-12-04 11:12:04
 * @Entity com.mrtan.bean.SupplierProduct
 */
public interface SupplierProductMapper {
//查供应商所有产品
    List<SupplierProduct> selectAll(SupplierProductVO supplierProductVO);


    SupplierProduct ishave(@Param("id") Integer id, @Param("supplier") Integer supplier);

    int addProduct(AddSupplierProductVO addSupplierProductVO);

    int remove(@Param("productid") int productid, @Param("supplierid") int supplierid);

    int update(UpdateSupplierProduct updateSupplierProduct);

    Integer selectQuantityById(@Param("product") Integer product);

    void updateQuantity(@Param("i") Integer i,@Param("product") Integer product);

    List<MCDto> selectProId(@Param("id") Integer id);

//SupplierProduct select();
}
